Show All
Previous property as it applies to the Range object.
Returns a Range object that represents the previous cell. This property emulates pressing SHIFT+TAB; unlike the key combination, however, the property returns the previous cell without selecting it.
On a protected sheet, this property returns the previous unlocked cell. On an unprotected sheet, this property always returns the cell immediately to the left of the specified cell.
Using this property when the active cell in the specified range is in column A will result in a run-time error.
expression.Previous
expression Required. An expression that returns a Range object.
Previous property as it applies to the Worksheet object.
Returns a Worksheet object that represents the previous sheet.
expression.Previous
expression Required. An expression that returns a Worksheet object.
As it applies to the Range object.
This example selects the previous unlocked cell on the active worksheet.
Spreadsheet1.ActiveCell.Previous.Select